To Create a Query Using the Where Clause

Follow these steps to create a new data query using the Where Clause.

From the Navigation pane, select Data manager, and then select Tag management.
From Data Manager, select Query Browser.
Click to expand My Queries context menu ( ), and then select + Create New Query.

The Create New Query dialog appears.
Enter the Query Name, and then click Ok.
The query name appears in the My Queries list.
Click Define Query.

The Query Builder dialog opens.
Select a Schema from the drop-down. For example,
Select a Class from the drop-down. For example,

To create a query with Advanced Mode, see Advanced Mode.
If you want to add a clause to the query, click to enable the Where Clause option. For example,

The Query Builder expands to allow you to include additional parameters to refine your query results:
Do the following:
1. Select a column from the Select Column list.
2. Select a condition from the Select Condition list.
3. Enter a Value in the box provided.
4. (Optional) Click + to add another Where Clause with "AND" or "OR" condition.
Note:
- The Column options vary depending on the Schema and Class selected in Steps 6 and 7.
- The Conditions options vary depending on the Column selected in Step 9.
Click Save.
The query is generated based on the parameters you have specified, and the qualifying records appear in grid format, below. For example,
Note:
- Starts with and Ends with conditions in where clause can be evaluated using the Like operator.
- For example, to fetch the Description property ending with value "XXXX", Like operator can be used with the value set as %XXXX and vice-versa as XXXX%.